How to: Change the scale of the category or series axis of a 3-D chart.
Solution:
Select the 3-D chart, double-click on the category (X) or series (Y) axis, click the 'Scale' tab, and type appropriate values in the corresponding boxes.
1) Select the desired 3-D chart.
a) If the chart is embedded on the worksheet, double-click on the chart. (A striped border with handles appears around the chart.)
b) If the chart is on a separate chart sheet, click the tab for the chart sheet.
2) Double-click on the category or series axis.
Category or series axis
3) Click the 'Scale' tab from the 'Format Axis' dialog box.
Format Axis dialog box
4) Type how often the tick marks should be labeled in the 'Number of Categories between Tick-Mark Labels' box.
EXAMPLE: To label every tick mark, type '1' in the box. To label every other tick mark, type '2' in the box.
5) Type the desired number of categories included in each pair of tick marks in the 'Number of Categories between Tick Marks' box.
6) (Optional) Select the 'Categories in Reverse Order' check box to display the current categories in reverse order.
7) Click 'OK'.
